SHOW FULL COLUMNS FROM `mtr_bus_route` [ RunTime:0.000530s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-602-I-0' LIMIT 1 [ RunTime:0.000219s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-602-I-0' LIMIT 1 [ RunTime:0.000235s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-602-O-0' LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-602-O-0' LIMIT 1 [ RunTime:0.000189s ]
SHOW FULL COLUMNS FROM `mtr_bus_stop` [ RunTime:0.000405s ]
SELECT `id`,`name` FROM `mtr_bus_stop` WHERE `id` IN ('RMB-20081','RMB-20082','RMB-20083','RMB-20084','RMB-20085','RMB-20086','RMB-20087','RMB-20088','RMB-20089') [ RunTime:0.000265s ]
SELECT `id`,`no`,`co`,`name`,`stop_list`,`orig`,`dest` FROM `mtr_bus_route` `r` WHERE `r`.`bound` = 'O' AND ( JSON_CONTAINS(stop_list, '"RMB-20081"') ) LIMIT 10 [ RunTime:0.067930s ]